Tag Archives: Mysql
How to prevent gaps/holes in a MySQL
Oct 28, 2014
Generally during the MySQL database development you create tables with a Primary Key, a very simple way to create a primary key is make it..
Read moreClean Variables in PHP
Sep 02, 2014
It’s always important to clean/sanitize variables that are submitted via web forms to prevent against all kinds of different malicious threat. Here is a complete..
Read more
How To Change Your Joomla Administrator Password
Jul 04, 2014
Navigate to phpMyAdmin and select the database for the Joomla! site in the left-hand drop-down list box. This will show the database tables on the..
Read moreHow much memory do PHP variables use?
Apr 12, 2014
There are cases when it might be quite important to know how much memory uses each variable in PHP script. The function memory_get_usage returns the..
Read moreDifference between MySql drop table, truncate table,
Apr 07, 2014
DROP command is used for deleting the table and its structure from the data base.Use this command when you don’t need that table any more…
Read moreFull-text search in MySQL
Mar 18, 2014
Normally, most of us use “SELECT * FROM table WHERE field1 LIKE ‘%$keyword%’” OR field2 LIKE ‘%$keyword%‘ ..etc” to search our table and get results…
Read more